<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<head>
<title>学生成绩管理系统</title>
<link rel="stylesheet" type="text/css" id="css" href="../style/main.css" />
<link rel="stylesheet" type="text/css" id="css"
	href="../style/style1.css" />
<link rel="stylesheet" type="text/css" id="css"
	href="../style/style.css" />

<style type="text/css">
<!--
table {
	border-spacing: 1px;
	border: 1px solid #A2C0DA;
}

td, th {
	padding: 2px 5px;
	border-collapse: collapse;
	text-align: left;
	font-weight: normal;
}

thead tr th {
	height: 50px;
	background: #B0D1FC;
	border: 1px solid white;
}

thead tr th.line1 {
	background: #D3E5FD;
}

thead tr th.line4 {
	background: #C6C6C6;
}

tbody tr td {
	height: 35px;
	background: #CBE2FB;
	border: 1px solid white;
	vertical-align: middle;
}

tbody tr td.line4 {
	background: #D5D6D8;
}

tbody tr th {
	height: 35px;
	background: #DFEDFF;
	border: 1px solid white;
	vertical-align: middle;
}

tfoot tr td {
	height: 35px;
	background: #FFFFFF;
	border: 1px solid white;
	vertical-align: middle;
}
-->
</style>

<script type="text/javascript" src="../js/common.js"></script>
</head>
<c:if test="${!(empty sessionScope.message)}">
	<script type="text/javascript">
		alert('<c:out value="${sessionScope.message}"/>');
	</script>
	<c:remove var="message" scope="session" />
</c:if>
<body>
	<div id="btm">
		<div id="main">

			<div id="header">
				<div id="top"></div>
				<div id="logo">
					<h1>信息查询</h1>
				</div>
				<div id="mainnav">
					<ul>
						<li><a href="studentIndex.jsp">首页</a></li>
						<li><a href="scServlet?action=listTeacherC">课程选择</a></li>
						<li><a href="scServlet?action=showStudentC">信息查询</a></li>
						<li><a href="changePwd.jsp">密码修改</a></li>
						<li><a href="../logoutServlet">退出</a></li>
					</ul>
					<span id="right"> <c:choose>
							<c:when test="${sessionScope.user.userType==2}">
								<font color=red>状态：已登录&nbsp;&nbsp;用户类别：学生用户&nbsp;&nbsp;用户名：${sessionScope.user.name}&nbsp;&nbsp;</font>
							</c:when>
							<c:otherwise>
								<font color=red>状态：未登录&nbsp;&nbsp;</font>
							</c:otherwise>
						</c:choose>
					</span>
				</div>
			</div>
			<div id="tabsJ">
				<ul>
					<li><a href="scServlet?action=showStudentC" title="个人成绩显示"><span>个人成绩显示</span></a></li>
					<li><a href="studentCheck.jsp" title="他人成绩查询"><span>他人成绩查询</span></a></li>
				</ul>
			</div>
			<div id="content" align="center">
				<div id="center">
					<BR /> <BR />
					<form method="post" action="scServlet?action=checkStudentC">
						<table width="800" align="center" cellpadding="0" cellspacing="0">
							<thead>
								<tr>
									<td width="70%"><h4>查询他人成绩&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</h4></td>
								</tr>
							</thead>

							<tr>
								<td colspan="2" width="100%">
									<table width="100%">
										<thead>
											<tr>
												<th align="center" class="line1" scope="col" colspan="12">
													<b><font color="red">请输入查询统计条件：</font></b>
												</th>
											</tr>
											<tr>
												<th align="center" class="line1" scope="col" colspan="1">
													<b>学生学号</b>
												</th>
												<th align="center" scope="col" colspan="3"><input
													name="studentNo" value="${requestScope.studentNo }" /></th>
												<th align="center" class="line1" scope="col" colspan="1">
													<b>学生班级</b>
												</th>
												<th align="center" scope="col" colspan="3"><input
													name="studentClass" value="${requestScope.studentClass }" /></th>
												<th align="center" class="line1" scope="col" colspan="1">
													<b>学生专业</b>
												</th>
												<th align="center" scope="col" colspan="3"><input
													name="studentMajor" value="${requestScope.studentMajor }" /></th>
											</tr>
											<tr>
												<th align="center" class="line1" scope="col" colspan="12">
													<input type="submit" value="查询" /> <input type="reset"
													value="重置" />
												</th>
											</tr>
											<tr>
												<th width="12%" align="center" scope="col" colspan="1"><b>学号</b>
												</th>
												<th width="11%" align="center" scope="col" colspan="1"><b>姓名</b>
												</th>
												<th width="10%" align="center" scope="col" colspan="2"><b>班级</b>
												</th>
												<th width="13%" align="center" scope="col" colspan="2"><b>专业</b>
												</th>
												<th width="10%" align="center" scope="col" colspan="1"><b>总学分</b>
												</th>
												<th width="10%" align="center" scope="col" colspan="1"><b>平均绩点</b>
												</th>
												<th width="13%" align="center" scope="col" colspan="1"><b>班级排名</b>
												</th>
												<th width="10%" align="center" scope="col" colspan="1"><b>专业排名</b>
												</th>
												<th width="10%" align="center" scope="col" colspan="2"><b>课程信息</b>
												</th>
											</tr>
										</thead>
										<tbody>
											<tr>
											<c:forEach items="${requestScope.list}" var="student">
												<th width="12%" align="center" scope="col" colspan="1">${student.studentNo }
												</th>
												<th width="11%" align="center" scope="col" colspan="1">${student.studentName }
												</th>
												<th width="10%" align="center" scope="col" colspan="2">${student.studentClass }
												</th>
												<th width="13%" align="center" scope="col" colspan="2">${student.studentMajor }
												</th>
												<th width="10%" align="center" scope="col" colspan="1">${student.sumCredit }
												</th>
												<th width="10%" align="center" scope="col" colspan="1">${student.avgCreditGPA }
												</th>
												<th width="13%" align="center" scope="col" colspan="1">${student.classRank }
												</th>
												<th width="10%" align="center" scope="col" colspan="1">${student.majorRank }
													<th width="10%" align="center" scope="col" colspan="2"><a
															href="scServlet?action=otherStudentShow&studentNo=${student.studentNo }&studentName=${student.studentName }">课程信息</a></th>
											</tr>
											</c:forEach>
										</tbody>
										<tbody>
												<tr>
													<td align="center" colspan="12"><c:if
															test="${requestScope.pageCount!=0&&requestScope.curPage!=1}">
															<a
																href='<c:url value="scServlet?action=checkStudentC&}&curPage=1&studentNo=${requestScope.studentNo }&studentClass=${requestScope.studentClass }&studentMajor=${requestScope.studentMajor }"/>'>首页</a>
															<a
																href='<c:url value="scServlet?action=checkStudentC&}&curPage=${requestScope.curPage-1}&studentNo=${requestScope.studentNo }&studentClass=${requestScope.studentClass }&studentMajor=${requestScope.studentMajor }"/>'>前一页</a>
														</c:if> <c:if
															test="${requestScope.pageCount==0||requestScope.curPage==1}&studentNo=${requestScope.studentNo }&studentClass=${requestScope.studentClass }&studentMajor=${requestScope.studentMajor }">首页 前一页</c:if>
														<c:if
															test="${requestScope.pageCount!=0&&requestScope.curPage!=requestScope.pageCount}">
															<a
																href='<c:url value="scServlet?action=checkStudentC&}&curPage=${requestScope.curPage+1}&studentNo=${requestScope.studentNo }&studentClass=${requestScope.studentClass }&studentMajor=${requestScope.studentMajor }"/>'>下一页</a>
															<a
																href='<c:url value="scServlet?action=checkStudentC&}&curPage=${requestScope.pageCount}&studentNo=${requestScope.studentNo }&studentClass=${requestScope.studentClass }&studentMajor=${requestScope.studentMajor }"/>'>尾页</a>
														</c:if> <c:if
															test="${requestScope.pageCount==0||requestScope.curPage==requestScope.pageCount}">下一页 尾页</c:if>
														&nbsp;
														第${requestScope.curPage}页/共${requestScope.pageCount}页
														&nbsp;</td>
												</tr>
											</tbody>
									</table>
								</td>
							</tr>
						</table>
					</form>
				</div>
			</div>

			<div id="footer">
				<div id="copyright">
					<div id="copy">
						<p align="center">CopyRight&copy;2010</p>
						<p>南京晓庄学院信息工程学院</p>
					</div>
				</div>
				<div id="bgbottom"></div>
			</div>

		</div>
	</div>
</body>
</html>
